How to: Use AutoFilter with Top Ten.
Solution:
Select 'Filter' from the 'Data' menu and select 'AutoFilter'. Click the down arrow button in the column where filtering criteria should be entered. Select '(Top Ten...)' from the drop-down list and specify the desired criteria in the 'Top Ten AutoFilter' dialog box.
NOTE: AutoFilter with Top Ten works only for fields that hold numbers.
1) Select any cell in a list.
2) Select the 'Data' menu and select 'Filter'. (A submenu appears.)
the Filter submenu
3) Select 'AutoFilter' from the submenu. (The cells at the top row of the list become drop-down lists.)
NOTE: The 'AutoFilter' command in the submenu should not have a check mark on the left. If it does, select 'AutoFilter' to uncheck it first. Then start from Step 2) again.
4) Click down arrow button in the column where filtering criteria should be typed. (A drop-down list appears.)
the filtering drop-down lists
5) Select '(Top Ten...)' from the drop-down list. (The Top Ten AutoFilter dialog box appears.)
6) Specify the following in the appropriate boxes in the 'Show' group:
7) Click 'OK' to close the 'Top Ten AutoFilter' dialog box and to show the filtering result.